"File in use" message when you try to open an Excel

Hi

I have exactly the Problem, that is descriped in the following MS Article.

But the Hotfix is installed, the FixIt does not help and I have Excel 2010 instead of 2007.

Has anyone other ideas or experience?

https://support.microsoft.com/en-us/kb/942146/

Symptoms

You open a remote shared folder in Windows Explorer that uses the Details view and for which the Preview Pane layout is enabled on a computer that is running Windows Vista, Windows Server 2008, Windows 7, or Windows Server 2008 R2. When you try to open a Microsoft Office Excel 2007 Workbook from the remote shared folder, you may receive the following message:

File in Use <var class="sbody-var">file_name</var> is locked for editing by <var class="sbody-var">user_name</var>


Thanks, Daniel

 

April 9th, 2015 8:02am

Hi Daniel,

This issue is a fairly common occurrence, and reasons of the problems are variously. We can narrow the reasons down as much as possible.

Please refer to this article, I think the methods of this article are more specific.

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/05/14/the-definitive-locked-file-post.aspx

And try these solutions step by step. Above all, you should  pay attention to the third solution Turn off the Preview Pane, Details Pane and pop ups that show information about file and desktop items, make sure you have unchecked Show pop-up description for folder and desktop items.

If you finish all of methods from this article, the problem still exists. Checking the permissions of users.

For instance, the permission of user 1 is only read and he opens the [shared] file, the document creates a temporary file in the same directory as the original file. Thus the document gets a temporary lock file. When other users open the [shared] file again, they get the error message file in use.

If you want to verify the reason of permission, checking the temporary file. This is a hidden file and it will be the same name as your document, but prefixed with a ~$ symbols.

The easiest way out is to delete the temporary file, but this not a long-term solution. Checking the permissions of users is radically.

Trying these solutions and let me know if they work. I am glad to help and forward to your reply.

Best Regards,

Emi

Free Windows Admin Tool Kit Click here and download it now
April 10th, 2015 4:53am

Uncheck 'Details Pane' helps for me!

Thanks Emi!!!

April 13th, 2015 5:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics